Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Register an account today and get great deals, offers and customised products only for you.
| Joomla! Version | 4.2.6 |
| PHP Version | 7.4.33 |
| Identity | guest |
| Response | 200 |
| Template | r_onsale |
| Database |
|
| 1 x afterRenderComponent com_virtuemart (13.62MB) (31.33%) | 188.44ms |
| 1 x afterRender (623.37KB) (12.39%) | 74.54ms |
| 1 x afterInitialise (8.34MB) (11.84%) | 71.20ms |
| 1 x beforeRenderRawModule mod_login (Login Form) (4.63MB) (7.17%) | 43.10ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Navigation (Product categories) on other pages) (2.98MB) (6.36%) | 38.27ms |
| 1 x afterRoute (3.19MB) (5.59%) | 33.63ms |
| 1 x afterLoad (3.73MB) (4.64%) | 27.89ms |
| 1 x afterRenderRawModule mod_virtuemart_category_search (VirtueMart Category Search Module) (1.05MB) (3.39%) | 20.38ms |
| 1 x afterRenderRawModule mod_virtuemart_product (VM - Featured products) (1.67MB) (3.27%) | 19.65ms |
| 1 x Before Access::preloadComponents (all components) (1.79MB) (2.64%) | 15.85ms |
| 1 x afterRenderRawModule mod_virtuemart_minicart (VM Mini Shopping Cart Module) (1.25MB) (2.22%) | 13.34ms |
| 1 x afterRenderRawModule mod_rca_virtuemart_products_listingmini (FEATURED PRODUCTS) (1.21MB) (2.08%) | 12.48ms |
| 1 x afterRenderRawModule mod_login (Login Form) (197.6KB) (0.85%) | 5.13ms |
| 1 x beforeRenderRawModule mod_gantry5_particle (Navigation (Product categories) on other pages) (4KB) (0.54%) | 3.22ms |
| 1 x beforeRenderRawModule mod_gantry5_particle (Current Offers) (17.77KB) (0.53%) | 3.16ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Current Offers) (51.58KB) (0.35%) | 2.12ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Copyright) (35.27KB) (0.24%) | 1.45ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Get Support) (32.77KB) (0.23%) | 1.40ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Payment logos) (5KB) (0.2%) | 1.20ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Information) (6KB) (0.2%) | 1.17ms |
| 1 x afterRenderRawModule mod_gantry5_particle (My Account) (6KB) (0.19%) | 1.13ms |
| 1 x After Access::preloadComponents (all components) (119.09KB) (0.15%) | 894μs |
| 1 x afterRenderModule mod_login (Login Form) (63.5KB) (0.15%) | 886μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (Copyright) (7.43KB) (0.11%) | 675μs |
| 1 x beforeRenderRawModule mod_custom (Register to save more) (6.87KB) (0.11%) | 662μs |
| 1 x beforeRenderRawModule mod_virtuemart_product (VM - Featured products) (6.32KB) (0.1%) | 621μs |
| 1 x afterRenderRawModule mod_custom (Register to save more) (4.01KB) (0.09%) | 533μs |
| 1 x beforeRenderRawModule mod_virtuemart_category_search (VirtueMart Category Search Module) (4.04KB) (0.07%) | 446μs |
| 1 x beforeRenderRawModule mod_virtuemart_minicart (VM Mini Shopping Cart Module) (2.06KB) (0.07%) | 438μs |
| 1 x After Access::getAssetRules (id:1 name:root.1) (24.98KB) (0.06%) | 369μs |
| 1 x afterRenderModule mod_gantry5_particle (Navigation (Product categories) on other pages) (91.12KB) (0.04%) | 270μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (Information) (1.01KB) (0.04%) | 252μs |
| 1 x afterRenderRawModule mod_custom (Offer Banner on Sidebar) (1000B) (0.04%) | 240μs |
| 1 x afterRenderModule mod_gantry5_particle (My Account) (2.88KB) (0.04%) | 239μs |
| 1 x beforeRenderModule mod_login (Login Form) (64.45KB) (0.04%) | 236μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (Get Support) (904B) (0.04%) | 235μs |
| 1 x afterRenderModule mod_gantry5_particle (Copyright) (2.38KB) (0.04%) | 221μs |
| 1 x afterRenderModule mod_gantry5_particle (Get Support) (3.25KB) (0.04%) | 212μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (My Account) (120B) (0.04%) | 211μs |
| 1 x afterRenderModule mod_gantry5_particle (Payment logos) (2.44KB) (0.04%) | 211μs |
| 1 x afterRenderModule mod_virtuemart_product (VM - Featured products) (25.94KB) (0.03%) | 210μs |
| 1 x afterRenderModule mod_gantry5_particle (Current Offers) (3KB) (0.03%) | 208μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (Payment logos) (712B) (0.03%) | 208μs |
| 1 x afterRenderModule mod_gantry5_particle (Information) (2.88KB) (0.03%) | 205μs |
| 1 x afterRenderModule mod_rca_virtuemart_products_listingmini (FEATURED PRODUCTS) (5.95KB) (0.03%) | 204μs |
| 1 x afterRenderModule mod_custom (Offer Banner on Sidebar) (2.25KB) (0.03%) | 175μs |
| 1 x beforeRenderModule mod_custom (Register to save more) (376B) (0.03%) | 172μs |
| 1 x beforeRenderComponent com_virtuemart (7.51KB) (0.03%) | 156μs |
| 1 x afterDispatch (2.25KB) (0.02%) | 149μs |
| 1 x afterRenderModule mod_virtuemart_category_search (VirtueMart Category Search Module) (1.26KB) (0.02%) | 124μs |
| 1 x afterRenderModule mod_custom (Register to save more) (1.26KB) (0.02%) | 118μs |
| 1 x afterRenderModule mod_virtuemart_minicart (VM Mini Shopping Cart Module) (1.27KB) (0.02%) | 99μs |
| 1 x afterRenderModule mod_custom (Register to save more) (1.27KB) (0.01%) | 74μs |
| 1 x afterRenderModule mod_login (Login Form) (2.52KB) (0.01%) | 72μs |
| 1 x beforeRenderRawModule mod_rca_virtuemart_products_listingmini (FEATURED PRODUCTS) (1.66KB) (0.01%) | 51μs |
| 1 x beforeRenderRawModule mod_custom (Offer Banner on Sidebar) (2.59KB) (0.01%) | 46μs |
| 1 x Before Access::getAssetRules (id:492 name:com_virtuemart) (456B) (0%) | 22μs |
| 1 x beforeRenderModule mod_rca_virtuemart_products_listingmini (FEATURED PRODUCTS) (752B) (0%) | 22μs |
| 1 x Before Access::getAssetRules (id:1 name:root.1) (3.55KB) (0%) | 20μs |
| 1 x After Access::getAssetRules (id:492 name:com_virtuemart) (1.61KB) (0%) | 9μs |
| 1 x beforeRenderModule mod_login (Login Form) (720B) (0%) | 8μs |
| 1 x beforeRenderModule mod_custom (Register to save more) (720B) (0%) | 8μs |
| 1 x beforeRenderModule mod_virtuemart_category_search (VirtueMart Category Search Module) (752B) (0%) | 7μs |
| 1 x beforeRenderModule mod_virtuemart_minicart (VM Mini Shopping Cart Module) (752B) (0%) | 7μs |
| 1 x beforeRenderModule mod_gantry5_particle (Navigation (Product categories) on other pages) (768B) (0%) | 7μs |
| 1 x beforeRenderModule mod_virtuemart_product (VM - Featured products) (736B) (0%) | 7μs |
| 1 x beforeRenderModule mod_gantry5_particle (Get Support) (720B) (0%) | 6μs |
| 1 x beforeRenderModule mod_custom (Offer Banner on Sidebar) (720B) (0%) | 6μs |
| 1 x beforeRenderModule mod_gantry5_particle (Current Offers) (736B) (0%) | 6μs |
| 1 x beforeRenderModule mod_gantry5_particle (Information) (720B) (0%) | 6μs |
| 1 x beforeRenderModule mod_gantry5_particle (My Account) (720B) (0%) | 6μs |
| 1 x beforeRenderModule mod_gantry5_particle (Copyright) (720B) (0%) | 6μs |
| 1 x beforeRenderModule mod_gantry5_particle (Payment logos) (720B) (0%) | 6μs |
SELECT @@SESSION.sql_mode;68μs1.59KB/libraries/src/Session/MetadataManager.php:184CopySELECT `session_id`
FROM `ly39srojgh48_session`
WHERE `session_id` = :session_id LIMIT 1160μs1.61KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `ly39srojgh48_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)446μs944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ly39srojgh48_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1492μs4.73KB/libraries/src/Component/ComponentHelper.php:393CopySELECT `id`,`rules`
FROM `ly39srojgh48_viewlevels`126μs1.73KB/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `ly39srojgh48_usergroups` AS `a`
LEFT JOIN `ly39srojgh48_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest185μs1.67KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `ly39srojgh48_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`1.13ms16.8KBParams/libraries/src/Plugin/PluginHelper.php:283CopySELECT * FROM ly39srojgh48_hikashop_config268μs44.94KB/administrator/components/com_hikashop/classes/config.php:16CopySET sql_mode=(SELECT REPLACE(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''), 'STRICT_TRANS_TABLES', ''));48μs1.25KB/administrator/components/com_hikashop/helpers/helper.php:3194CopySELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component`
FROM `ly39srojgh48_menu` AS `m`
LEFT JOIN `ly39srojgh48_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id`
WHERE
(
(`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2)
ORDER BY `m`.`lft`1.27ms223.05KBParams/libraries/src/Menu/SiteMenu.php:166CopySHOW TABLES LIKE "ly39srojgh48_virtuemart_configs"378μs872B/administrator/components/com_virtuemart/helpers/vmtable.php:792CopySELECT `config` FROM `ly39srojgh48_virtuemart_configs` WHERE `virtuemart_config_id` = "1";87μs872B/administrator/components/com_virtuemart/helpers/config.php:452CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `ly39srojgh48_assets`
WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43)503μs10.5KBParams/libraries/src/Access/Access.php:357CopySELECT *
FROM `ly39srojgh48_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC159μs2.44KB/libraries/src/Language/LanguageHelper.php:142CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `ly39srojgh48_template_styles` AS `s`
LEFT JOIN `ly39srojgh48_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id`
WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1370μs1.69KB/administrator/components/com_templates/src/Model/StyleModel.php:771CopySELECT * FROM `ly39srojgh48_menu` WHERE `link` like "index.php?option=com_virtuemart%" and (language="*" or language = "en-GB" ) AND client_id=0 AND published=1 AND ( access="1" OR access="5" ) ORDER BY `language` DESC666μs4.53KB/components/com_virtuemart/router.php:1643CopySELECT l.virtuemart_category_id FROM `ly39srojgh48_virtuemart_categories_en_gb` as l WHERE l.slug = "music-components"93μs3.35KB/components/com_virtuemart/router.php:1571CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "16"191μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "16" ORDER BY `ordering`98μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT count(`p`.virtuemart_product_id) AS total
FROM `ly39srojgh48_virtuemart_product_categories` as `pc`
LEFT JOIN `ly39srojgh48_virtuemart_products` as `p` ON `pc`.virtuemart_product_id = `p`.virtuemart_product_id
WHERE `pc`.`virtuemart_category_id` = "16"
AND `p`.`virtuemart_vendor_id` = "1"
AND `p`.`published` = "1"211μs872B/administrator/components/com_virtuemart/models/category.php:663CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM ly39srojgh48_virtuemart_categories
WHERE `virtuemart_category_id`= 1675μs944B/administrator/components/com_virtuemart/models/category.php:1078CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM ly39srojgh48_virtuemart_categories
WHERE `virtuemart_category_id`= 172μs944B/administrator/components/com_virtuemart/models/category.php:1078CopySELECT l.virtuemart_category_id, l.category_name, published FROM `ly39srojgh48_virtuemart_categories` as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE l.virtuemart_category_id = 186μs1KB/administrator/components/com_virtuemart/models/category.php:1024CopySELECT l.virtuemart_category_id, l.category_name, published FROM `ly39srojgh48_virtuemart_categories` as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE l.virtuemart_category_id = 1682μs1KB/administrator/components/com_virtuemart/models/category.php:1024CopySELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM ly39srojgh48_template_styles AS s
WHERE s.client_id = 0 AND s.template = 'r_onsale'
ORDER BY s.id245μs1.23KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "1"192μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "1" ORDER BY `ordering`101μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT l.virtuemart_category_id, l.category_name, published FROM `ly39srojgh48_virtuemart_categories` as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE l.virtuemart_category_id = 196μs1KB/administrator/components/com_virtuemart/models/category.php:1024CopySELECT c.* FROM ly39srojgh48_virtuemart_customs as c INNER JOIN ly39srojgh48_virtuemart_product_customfields as pc on (c.virtuemart_custom_id=pc.virtuemart_custom_id)
INNER JOIN ly39srojgh48_virtuemart_product_categories as cat ON (pc.virtuemart_product_id=cat.virtuemart_product_id) WHERE virtuemart_category_id="16" and searchable="1" and (field_type="S" or field_type="P") and c.published = 1 GROUP BY c.virtuemart_custom_id652μs4.3KB/components/com_virtuemart/views/category/view.html.php:610CopySELECT * FROM `ly39srojgh48_virtuemart_shoppergroups` WHERE `default` = "2" AND (`virtuemart_vendor_id` = "1" OR `shared` = "1") AND `published`="1"168μs3.94KB/administrator/components/com_virtuemart/models/shoppergroup.php:101CopySELECT `ly39srojgh48_virtuemart_shoppergroups`.* FROM `ly39srojgh48_virtuemart_shoppergroups` WHERE `ly39srojgh48_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"101μs3.94KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySHOW FULL COLUMNS FROM `ly39srojgh48_virtuemart_userfields`534μs10.39KB/administrator/components/com_virtuemart/helpers/vmtable.php:753CopySELECT * FROM `ly39srojgh48_virtuemart_userfields` WHERE 1 = 1 AND `account`="1" AND published = 1 AND FIND_IN_SET(name, 'address_type') = 0 ORDER BY ordering423μs27.77KB/administrator/components/com_virtuemart/helpers/vmmodel.php:504CopySELECT * FROM `ly39srojgh48_virtuemart_userfields` WHERE 1 = 1 AND `shipment`="1" AND published = 1 AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0 ORDER BY ordering318μs12.64KB/administrator/components/com_virtuemart/helpers/vmmodel.php:504CopySELECT p.`virtuemart_product_id`
FROM `ly39srojgh48_virtuemart_products` as p
LEFT JOIN `ly39srojgh48_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( `pc`.`virtuemart_category_id` IN (16) AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`product_special`="1" AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY `p`.product_sku DESC, p.`virtuemart_product_id` DESC LIMIT 12218μs840B/administrator/components/com_virtuemart/helpers/vmmodel.php:867CopySELECT p.`virtuemart_product_id`
FROM `ly39srojgh48_virtuemart_products` as p
LEFT JOIN `ly39srojgh48_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( `pc`.`virtuemart_category_id` IN (16) AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`product_discontinued`="1" AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY `p`.product_sku DESC, p.`virtuemart_product_id` DESC LIMIT 12198μs840B/administrator/components/com_virtuemart/helpers/vmmodel.php:867CopySELECT p.`virtuemart_product_id`
FROM `ly39srojgh48_virtuemart_products` as p
LEFT JOIN `ly39srojgh48_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( `pc`.`virtuemart_category_id` IN (16) AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY p.`created_on` DESC, p.`virtuemart_product_id` DESC LIMIT 4369μs968B/administrator/components/com_virtuemart/helpers/vmmodel.php:867CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "48"217μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "48" ORDER BY `ordering`106μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "48" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC208μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "48"90μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 48108μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "2"166μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "3"158μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "4"157μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "5"152μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "6"151μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "7"153μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "8"150μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "9"150μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "10"150μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "11"149μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "12"158μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "13"148μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "14"150μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "15"154μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_manufacturers`.* ,`ly39srojgh48_virtuemart_manufacturers_en_gb`.* FROM `ly39srojgh48_virtuemart_manufacturers` INNER JOIN `ly39srojgh48_virtuemart_manufacturers_en_gb` ON `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `ly39srojgh48_virtuemart_manufacturers_en_gb`.`virtuemart_manufacturer_id` WHERE `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "3"151μs4.19KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (48) AND c.`published` = "1" ORDER BY field.`ordering` ASC208μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT * FROM `ly39srojgh48_virtuemart_currencies` AS c
LEFT JOIN `ly39srojgh48_virtuemart_vendors` AS v ON c.virtuemart_currency_id = v.vendor_currency
WHERE v.virtuemart_vendor_id = "1"190μs7.75KB/administrator/components/com_virtuemart/models/vendor.php:323CopySELECT `ly39srojgh48_virtuemart_currencies`.* FROM `ly39srojgh48_virtuemart_currencies` WHERE `ly39srojgh48_virtuemart_currencies`.`virtuemart_currency_id` = "47"132μs4.34KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT c.* FROM ly39srojgh48_virtuemart_calcs as c LEFT JOIN ly39srojgh48_virtuemart_calc_shoppergroups as cs ON cs.virtuemart_calc_id=c.virtuemart_calc_id WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( ISNULL(publish_up) OR ( ISNULL("publish_up") or publish_up="0000-00-00 00:00:00") OR publish_up <= "2025-04-14 02:10:11" )
AND ( ISNULL(publish_down) OR ( ISNULL("publish_down") or publish_down="0000-00-00 00:00:00") OR publish_down >= "2025-04-14 02:10:11" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)177μs4.3KB/administrator/components/com_virtuemart/helpers/calculationh.php:176CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "48"102μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "47"214μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "47" ORDER BY `ordering`92μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "47" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC198μs12.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "47"83μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 47105μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (47) AND c.`published` = "1" ORDER BY field.`ordering` ASC211μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "47"97μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "46"210μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "46" ORDER BY `ordering`96μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "46" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC193μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "46"83μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 46106μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT `ly39srojgh48_virtuemart_manufacturers`.* ,`ly39srojgh48_virtuemart_manufacturers_en_gb`.* FROM `ly39srojgh48_virtuemart_manufacturers` INNER JOIN `ly39srojgh48_virtuemart_manufacturers_en_gb` ON `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `ly39srojgh48_virtuemart_manufacturers_en_gb`.`virtuemart_manufacturer_id` WHERE `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "1"149μs4.19KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (46) AND c.`published` = "1" ORDER BY field.`ordering` ASC194μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "46"95μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "45"217μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "45" ORDER BY `ordering`87μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "45" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC194μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "45"83μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 45105μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (45) AND c.`published` = "1" ORDER BY field.`ordering` ASC202μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "45"95μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "36"135μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "37"140μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "21"121μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT p.`virtuemart_product_id`
FROM `ly39srojgh48_virtuemart_products` as p
LEFT JOIN `ly39srojgh48_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( `pc`.`virtuemart_category_id` IN (16) AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND pp.`product_price`>"0.001" AND p.`published`="1" AND ( p.`virtuemart_product_id` NOT IN (48,47,46,45) ) )
group by p.`virtuemart_product_id`
ORDER BY p.`product_sales` DESC, p.`virtuemart_product_id` DESC LIMIT 4477μs968B/administrator/components/com_virtuemart/helpers/vmmodel.php:867CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "44"210μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "44" ORDER BY `ordering`96μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "44" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC196μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "44"84μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 44104μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT `ly39srojgh48_virtuemart_manufacturers`.* ,`ly39srojgh48_virtuemart_manufacturers_en_gb`.* FROM `ly39srojgh48_virtuemart_manufacturers` INNER JOIN `ly39srojgh48_virtuemart_manufacturers_en_gb` ON `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `ly39srojgh48_virtuemart_manufacturers_en_gb`.`virtuemart_manufacturer_id` WHERE `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "4"145μs4.19KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (44) AND c.`published` = "1" ORDER BY field.`ordering` ASC195μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "44"94μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "43"215μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "43" ORDER BY `ordering`88μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "43" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC193μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "43"86μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 43104μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (43) AND c.`published` = "1" ORDER BY field.`ordering` ASC200μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "43"96μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "42"208μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "42" ORDER BY `ordering`90μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "42" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC193μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "42"83μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 42103μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (42) AND c.`published` = "1" ORDER BY field.`ordering` ASC201μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "42"103μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "41"210μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "41" ORDER BY `ordering`89μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "41" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC202μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "41"82μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 41106μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (41) AND c.`published` = "1" ORDER BY field.`ordering` ASC201μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "41"98μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "28"122μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "18"119μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id`
FROM `ly39srojgh48_virtuemart_products` as p
LEFT JOIN `ly39srojgh48_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
WHERE ( `pc`.`virtuemart_category_id` IN (16) AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" AND ( p.`virtuemart_product_id` NOT IN (48,47,46,45,44,43,42,41) ) )
group by p.`virtuemart_product_id`
ORDER BY `p`.product_sku DESC, p.`virtuemart_product_id` DESC LIMIT 24350μs1.57KB/administrator/components/com_virtuemart/helpers/vmmodel.php:867CopySELECT FOUND_ROWS()39μs872B/administrator/components/com_virtuemart/helpers/vmmodel.php:881CopySELECT DISTINCT l.virtuemart_manufacturer_id, l.mf_name FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l INNER JOIN `ly39srojgh48_virtuemart_product_manufacturers` AS pm ON pm.`virtuemart_manufacturer_id` = l.`virtuemart_manufacturer_id` INNER JOIN `ly39srojgh48_virtuemart_products` as p ON p.`virtuemart_product_id` = pm.`virtuemart_product_id` INNER JOIN `ly39srojgh48_virtuemart_product_categories` as pc ON pc.`virtuemart_product_id` = pm.`virtuemart_product_id` WHERE p.`published` = "1" AND pc.`virtuemart_category_id` = "16" ORDER BY `mf_name`269μs1.16KB/administrator/components/com_virtuemart/models/manufacturer.php:218CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "4"82μs872B/components/com_virtuemart/router.php:1571CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "1"66μs872B/components/com_virtuemart/router.php:1571CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "5"64μs872B/components/com_virtuemart/router.php:1571CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "2"61μs872B/components/com_virtuemart/router.php:1571CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "6"61μs872B/components/com_virtuemart/router.php:1571CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "3"61μs872B/components/com_virtuemart/router.php:1571CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "28"229μs24.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "28" ORDER BY `ordering`97μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "28" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC205μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "28"89μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 28108μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT `ly39srojgh48_virtuemart_manufacturers`.* ,`ly39srojgh48_virtuemart_manufacturers_en_gb`.* FROM `ly39srojgh48_virtuemart_manufacturers` INNER JOIN `ly39srojgh48_virtuemart_manufacturers_en_gb` ON `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `ly39srojgh48_virtuemart_manufacturers_en_gb`.`virtuemart_manufacturer_id` WHERE `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "2"145μs4.19KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (28) AND c.`published` = "1" ORDER BY field.`ordering` ASC195μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "28"95μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "27"209μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "27" ORDER BY `ordering`90μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "27" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC194μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "27"87μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 27105μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (27) AND c.`published` = "1" ORDER BY field.`ordering` ASC204μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "27"96μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "14"220μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "14" ORDER BY `ordering`90μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "14" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC195μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "14"84μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 14119μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (14) AND c.`published` = "1" ORDER BY field.`ordering` ASC201μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "14"96μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "8"442μs24.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "8" ORDER BY `ordering`102μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "8" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC202μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "8"86μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 8105μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (8) AND c.`published` = "1" ORDER BY field.`ordering` ASC202μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "8"111μs2.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "30"211μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "30" ORDER BY `ordering`90μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "30" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC204μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "30"94μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 30104μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (30) AND c.`published` = "1" ORDER BY field.`ordering` ASC200μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "30"96μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "29"207μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "29" ORDER BY `ordering`87μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "29" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC195μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "29"87μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 29105μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (29) AND c.`published` = "1" ORDER BY field.`ordering` ASC206μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "29"97μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "15"218μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "15" ORDER BY `ordering`95μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "15" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC194μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "15"84μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 15104μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (15) AND c.`published` = "1" ORDER BY field.`ordering` ASC209μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "15"96μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "12"209μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "12" ORDER BY `ordering`97μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "12" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC193μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "12"84μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 12104μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (12) AND c.`published` = "1" ORDER BY field.`ordering` ASC208μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "12"97μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "34"215μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "34" ORDER BY `ordering`90μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "34" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC194μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "34"81μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 34105μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (34) AND c.`published` = "1" ORDER BY field.`ordering` ASC208μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "34"96μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "33"210μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "33" ORDER BY `ordering`90μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "33" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC193μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "33"80μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 33104μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (33) AND c.`published` = "1" ORDER BY field.`ordering` ASC204μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "33"97μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "17"208μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "17" ORDER BY `ordering`91μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "17" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC195μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "17"84μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 17107μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (17) AND c.`published` = "1" ORDER BY field.`ordering` ASC201μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "17"96μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "3"207μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "3" ORDER BY `ordering`92μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "3" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC195μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "3"83μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 3111μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (3) AND c.`published` = "1" ORDER BY field.`ordering` ASC203μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "3"103μs2.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "40"211μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "40" ORDER BY `ordering`91μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "40" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC193μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "40"88μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 40105μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (40) AND c.`published` = "1" ORDER BY field.`ordering` ASC203μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "40"96μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "39"211μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "39" ORDER BY `ordering`89μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "39" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC193μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "39"82μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 39108μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (39) AND c.`published` = "1" ORDER BY field.`ordering` ASC202μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "39"97μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "20"210μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "20" ORDER BY `ordering`88μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "20" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC194μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "20"86μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 20106μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (20) AND c.`published` = "1" ORDER BY field.`ordering` ASC201μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "20"103μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "9"208μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "9" ORDER BY `ordering`90μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "9" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC201μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "9"83μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 9104μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (9) AND c.`published` = "1" ORDER BY field.`ordering` ASC201μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "9"111μs2.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "26"214μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "26" ORDER BY `ordering`89μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "26" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC202μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "26"86μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 26105μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (26) AND c.`published` = "1" ORDER BY field.`ordering` ASC249μs8.42KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "26"98μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "25"210μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "25" ORDER BY `ordering`89μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "25" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC194μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "25"85μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 25104μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (25) AND c.`published` = "1" ORDER BY field.`ordering` ASC240μs8.42KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "25"98μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "13"207μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "13" ORDER BY `ordering`93μs32.85KB/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "13" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC196μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "13"83μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 13104μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (13) AND c.`published` = "1" ORDER BY field.`ordering` ASC234μs8.42KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "13"96μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "1"211μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1" ORDER BY `ordering`91μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC194μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "1"83μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1104μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (1) AND c.`published` = "1" ORDER BY field.`ordering` ASC232μs8.42KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "1"104μs2.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "22"341μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "22" ORDER BY `ordering`102μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "22" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC206μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "22"90μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 22105μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (22) AND c.`published` = "1" ORDER BY field.`ordering` ASC201μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "22"98μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "11"208μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "11" ORDER BY `ordering`88μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "11" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC197μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "11"85μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 11105μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (11) AND c.`published` = "1" ORDER BY field.`ordering` ASC206μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "11"105μs2.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "38"208μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "38" ORDER BY `ordering`90μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "38" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC194μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "38"81μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 38105μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (38) AND c.`published` = "1" ORDER BY field.`ordering` ASC207μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "38"97μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "37"210μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "37" ORDER BY `ordering`96μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "37" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC194μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "37"82μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 37106μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (37) AND c.`published` = "1" ORDER BY field.`ordering` ASC208μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "37"97μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "25"124μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "29"122μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "19"115μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "26"114μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "17"119μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "24"119μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "16"133μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 16) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC554μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT `ly39srojgh48_virtuemart_vendors`.* ,`ly39srojgh48_virtuemart_vendors_en_gb`.* FROM `ly39srojgh48_virtuemart_vendors` INNER JOIN `ly39srojgh48_virtuemart_vendors_en_gb` ON `ly39srojgh48_virtuemart_vendors`.`virtuemart_vendor_id` = `ly39srojgh48_virtuemart_vendors_en_gb`.`virtuemart_vendor_id` WHERE `ly39srojgh48_virtuemart_vendors`.`virtuemart_vendor_id` = "1"186μs4.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_vendor_medias` WHERE `virtuemart_vendor_id` = "1" ORDER BY `ordering`57μs840B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `ly39srojgh48_modules` AS `m`
LEFT JOIN `ly39srojgh48_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `ly39srojgh48_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id`
WHERE
(
(
(`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND
(`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0)
ORDER BY `m`.`position`,`m`.`ordering`1.31ms22.63KBParams/libraries/src/Cache/Controller/CallbackController.php:52CopySELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM ly39srojgh48_fields AS a
LEFT JOIN `ly39srojgh48_languages` AS l ON l.lang_code = a.language
LEFT JOIN ly39srojgh48_users AS uc ON uc.id=a.checked_out
LEFT JOIN ly39srojgh48_viewlevels AS ag ON ag.id = a.access
LEFT JOIN ly39srojgh48_users AS ua ON ua.id = a.created_user_id
LEFT JOIN ly39srojgh48_fields_groups AS g ON g.id = a.group_id
WHERE
(
(`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND
(`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform
ORDER BY a.ordering ASC897μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 0) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC660μs7.14KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "7" ORDER BY `ordering`102μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "2" ORDER BY `ordering`81μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "3" ORDER BY `ordering`77μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "6" ORDER BY `ordering`76μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "5" ORDER BY `ordering`83μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "4" ORDER BY `ordering`78μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 7) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC521μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 2) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC503μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 3) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC500μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 1) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC646μs8.17KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "15" ORDER BY `ordering`96μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "11" ORDER BY `ordering`112μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "12" ORDER BY `ordering`81μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "10" ORDER BY `ordering`76μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "14" ORDER BY `ordering`75μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "8" ORDER BY `ordering`75μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "13" ORDER BY `ordering`75μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "9" ORDER BY `ordering`102μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 15) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC520μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 11) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC479μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 12) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC456μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 10) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC468μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 14) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC497μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 8) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC506μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 13) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC533μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 9) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC544μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 6) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC532μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 5) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC551μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 4) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC556μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT * FROM ly39srojgh48_virtuemart_calcs LEFT JOIN ly39srojgh48_virtuemart_calc_shoppergroups using(virtuemart_calc_id)WHERE
`calc_kind`="DBTaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-04-14 02:10:11" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-04-14 02:10:11" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)190μs4.36KB/administrator/components/com_virtuemart/helpers/calculationh.php:1522CopySELECT * FROM ly39srojgh48_virtuemart_calcs LEFT JOIN ly39srojgh48_virtuemart_calc_shoppergroups using(virtuemart_calc_id)WHERE
`calc_kind`="TaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-04-14 02:10:11" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-04-14 02:10:11" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)161μs4.36KB/administrator/components/com_virtuemart/helpers/calculationh.php:1522CopySELECT * FROM ly39srojgh48_virtuemart_calcs LEFT JOIN ly39srojgh48_virtuemart_calc_shoppergroups using(virtuemart_calc_id)WHERE
`calc_kind`="DATaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-04-14 02:10:11" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-04-14 02:10:11" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)184μs4.36KB/administrator/components/com_virtuemart/helpers/calculationh.php:1522CopySELECT `a`.`menutype`,`a`.`title`
FROM `ly39srojgh48_menu_types` AS `a`
WHERE `a`.`client_id` = 0149μs1.11KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138CopySELECT m.id, m.alias, m.path AS route, m.level, m.parent_id
FROM ly39srojgh48_menu AS m
WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0
ORDER BY m.lft757μs15.05KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791CopySELECT m.id, m.alias, m.path AS route, m.level, m.parent_id
FROM ly39srojgh48_menu AS m
WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0
ORDER BY m.lft704μs15.05KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791CopySELECT p.`virtuemart_product_id`
FROM `ly39srojgh48_virtuemart_products` as p
LEFT JOIN `ly39srojgh48_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY RAND() LIMIT 5286μs1000B/administrator/components/com_virtuemart/helpers/vmmodel.php:867CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "16"222μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "16" ORDER BY `ordering`101μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "16" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC206μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "16"85μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 16108μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (16) AND c.`published` = "1" ORDER BY field.`ordering` ASC205μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "16"100μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "19"209μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "19" ORDER BY `ordering`93μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "19" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC196μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "19"85μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 19116μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (19) AND c.`published` = "1" ORDER BY field.`ordering` ASC222μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "19"95μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "31"222μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "31" ORDER BY `ordering`90μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "31" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC193μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "31"90μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 31107μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (31) AND c.`published` = "1" ORDER BY field.`ordering` ASC203μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "31"104μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "22"130μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT p.`virtuemart_product_id`
FROM `ly39srojgh48_virtuemart_products` as p
LEFT JOIN `ly39srojgh48_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY RAND() LIMIT 8247μs1.07KB/administrator/components/com_virtuemart/helpers/vmmodel.php:867CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "6"215μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "6" ORDER BY `ordering`93μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "6" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC211μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "6"85μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 6106μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (6) AND c.`published` = "1" ORDER BY field.`ordering` ASC203μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "6"108μs2.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "4"212μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "4" ORDER BY `ordering`91μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "4" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC197μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "4"85μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 4104μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (4) AND c.`published` = "1" ORDER BY field.`ordering` ASC214μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "4"109μs2.3KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "23"207μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "23" ORDER BY `ordering`94μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "23" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC194μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "23"86μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 23108μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (23) AND c.`published` = "1" ORDER BY field.`ordering` ASC202μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "23"97μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "2"216μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "2" ORDER BY `ordering`91μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "2" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 02:10:11" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-14 02:10:11" ) ) ORDER BY `product_price` DESC194μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "2"81μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 2113μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (2) AND c.`published` = "1" ORDER BY field.`ordering` ASC202μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "2"105μs2.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "23"131μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor`
FROM `ly39srojgh48_scheduler_tasks` AS `a`
LEFT JOIN `ly39srojgh48_users` AS `uc` ON `uc`.`id` = `a`.`checked_out`
WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now
ORDER BY `a`.`title` asc305μs4.45KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor`
FROM `ly39srojgh48_scheduler_tasks` AS `a`
LEFT JOIN `ly39srojgh48_users` AS `uc` ON `uc`.`id` = `a`.`checked_out`
WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL
ORDER BY `a`.`title` asc208μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy